package com.cn.Mapper.vipMapper;

import com.cn.entity.vip.Vipcustomer;
import com.cn.entity.vip.Vipcustomer_Search;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface VipcustomerMapper {
    /**
     * 添加VIP客户
     */
 public int insertVipcustomer(Vipcustomer vipcustomer);

    /**
     * 删除VIP客户
     */
 public  int deleteVipcoustomer(@Param("id") String id);

    /**
     * 更新VIP客户
     * @return
     */
 public int updateVipcustomer(@Param("id") String id,@Param("name") String username,@Param("point")String point,@Param("card_id") String card_id,@Param("card_grade")String card_grade,@Param("password") String password ,@Param("mobilephone") String mobilephone);

    /**
     * 显示所有VIP客户
     */
    public  List<Vipcustomer>selectVipcustomer();

    /**
     * 4.通过卡号检验vip
     */
    public Vipcustomer loginByCartId(@Param("card_id") String card_id);
    /**
     * 检索vip的信息通过卡号
     * 1.清空t_vip_search
     * 2.插入到t_vip_search
     * 3.展示t_vip_search
     *
     */
    public  int emptyVip_Search();
    public  int insertVipByIdCard(@Param("card_id")String card_id);
    public  List<Vipcustomer_Search>showSearch();
}
//@Param("id") String id,@Param("name") String username,@Param("point")String point,@Param("card_id") String card_id,@Param("card_grade")String card_grade,@Param("password") String password ,@Param("mobilephone") String mobilephone